package servlet;

import com.mysql.cj.jdbc.MysqlDataSource;
import pojo.Dept;
import service.DeptService;
import service.impl.DeptServiceimpl;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.util.List;

@WebServlet(urlPatterns = "/dept")
public class DeptServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
       doPost(req, resp);
    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        DeptService deptService=new DeptServiceimpl();
        req.setCharacterEncoding("utf-8");
        String action=req.getParameter("action");
        if("list".equals((action))){
            String dname=req.getParameter("dname");
            String dpass=req.getParameter("dpass");
            String dsex=req.getParameter("dsex");
            Dept co=new Dept(dname,dpass,dsex);
            List<Dept> depts=deptService.findAll(co);
            req.setAttribute("depts",depts);
            req.setAttribute("co",co);
            req.getRequestDispatcher("/list.jsp").forward(req,resp);
        } else if ("add".equals(action)) {
            String dname=req.getParameter("dname");
            String dpass=req.getParameter("dpass");
            String dsex=req.getParameter("dsex");
            int result=deptService.addDept(new Dept(dname,dpass,dsex));
            if(result>0){
                resp.sendRedirect("dept?action=list");
            }

        } else if ("delete".equals(action)) {
            String sid=req.getParameter("id");
            int id=Integer.parseInt(sid);
            int result=deptService.deleteDeptById(id);
           //重定向
            resp.sendRedirect("dept?action=list");

        } else if ("toupdate".equals(action)) {
            String sid=req.getParameter("id");
            int id=Integer.parseInt(sid);
            Dept co=deptService.findDeptById(id);
            req.setAttribute("co",co);
            req.getRequestDispatcher("/update.jsp").forward(req,resp);

        } else if ("update".equals(action)) {
            String sid=req.getParameter("id");
            int id=Integer.parseInt(sid);
            String dname=req.getParameter("dname");
            String dpass=req.getParameter("dpass");
            String dsex=req.getParameter("dsex");
            int result=deptService.updateDept(new Dept(id,dname,dpass,dsex));
            if(result>0){
                //重定向
                resp.sendRedirect("dept?action=list");
            }

        }

    }
}
